SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[usp_GetTopFiveNewRegisterCompany]
AS 
    SELECT TOP ( 5 )
            JOL_Employer_Account,
            JOL_Employer_Name,
            JOL_Employer_Industry,
            JOL_Employer_Type,
			convert(varchar(10),JOL_Employer_VerifyTime,120)		-- doo 20110215            
    FROM    dbo.JOL_Employer
	where JOL_Employer_VerifyStatus = '已审核'						-- doo 20110215
    ORDER BY JOL_Employer_VerifyTime,JOL_Employer_AddTime DESC		-- doo 20110215


GO
